package com.yngrp.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Transient;

import org.jeecgframework.core.common.entity.IdEntity;
import org.jeecgframework.poi.excel.annotation.Excel;

/**
 *  @Description: 集团户号明细
 *  @author  SLH
 *  @date  20160817
 */
@Entity
@Table(name = "yl_task_customerno_detail")
public class TaskCustomerNoDetail extends IdEntity implements java.io.Serializable{
	 private static final long serialVersionUID = 1L;
		
	/**关联集团实体**/
	private GroupInfo groupInfo;
	
	/**关联电费查询任务实体**/
	private TaskElecQuery queryTask;
	
	/**集团户号**/
	@Excel(name = "户号",width = 20)
	private String customerNo;
	
	/**集团名称**/
	@Excel(name = "集团名称",width = 35)
	private String groupName;
	
	/** 邮箱 **/
	@Excel(name = "邮箱",width = 25)
	private String contactEmail;
	
	/**电费查询方式编码**/
	private String queryMode;
	
	/** 查询方式 **/
	@Excel(name = "查询方式",width = 15)
	private String queryModeDesc;
	
	/** 查询日期 **/
	@Excel(name = "查询日期",width = 20)
	private String queryDate;
	
	/**集团户号电费额度**/
	@Excel(name = "电费（元）",width = 20)
	private Double elecAmount;
	


	@ManyToOne(fetch = FetchType.EAGER)
	@JoinColumn(name = "group_id")
	public GroupInfo getGroupInfo() {
		return groupInfo;
	}

	public void setGroupInfo(GroupInfo groupInfo) {
		this.groupInfo = groupInfo;
	}

	@ManyToOne(fetch = FetchType.EAGER)
	@JoinColumn(name = "task_id")
	public TaskElecQuery getQueryTask() {
		return queryTask;
	}

	public void setQueryTask(TaskElecQuery queryTask) {
		this.queryTask = queryTask;
	}

	@Column(name ="customer_no")
	public String getCustomerNo() {
		return customerNo;
	}

	public void setCustomerNo(String customerNo) {
		this.customerNo = customerNo;
	}

	@Column(name ="elec_amount")
	public Double getElecAmount() {
		return elecAmount;
	}

	public void setElecAmount(Double elecAmount) {
		this.elecAmount = elecAmount;
	}

	@Transient
	public String getGroupName() {
		return groupName;
	}

	public void setGroupName(String groupName) {
		this.groupName = groupName;
	}

	@Transient
	public String getContactEmail() {
		return contactEmail;
	}

	public void setContactEmail(String contactEmail) {
		this.contactEmail = contactEmail;
	}
	
	@Column(name ="querymode")
	public String getQueryMode() {
		return queryMode;
	}

	public void setQueryMode(String queryMode) {
		this.queryMode = queryMode;
	}

	@Column(name ="querymode_desc")
	public String getQueryModeDesc() {
		return queryModeDesc;
	}

	public void setQueryModeDesc(String queryModeDesc) {
		this.queryModeDesc = queryModeDesc;
	}

	@Transient
	public String getQueryDate() {
		return queryDate;
	}

	public void setQueryDate(String queryDate) {
		this.queryDate = queryDate;
	}

	
}
